2013-08-20 - 6411 -300 - Rel Notes - DSSCO Size L duplication. #DotNetReleases2013
Release Notes
6411.300 - Rel Notes- DSSCO Size L duplication
Admin Info
Purpose
|
DSSCO Size L duplication.
|
Release No#
|
001
|
Submitted on
|
08/20/2013
|
Submitted by
|
Venkat A
|
Source/Destination Systems
|
NEC DEV/NEC QA
|
Release Sent To
|
Saravanan
|
Objects Created By
|
Venkat A
|
Objects Tested By
|
Venkat A
|
Transport and Technical Objects
Location Objects Name
|
\\10.114.165.54\dev\DSSCODEV\Move To Q\Size L\
- SSIS Packages\OpenPOs.dtsx
- Script.sql
|
Release Notes
For Infrastructure
Please take backup of below procedure and table in QA before executing the script on QA DB.
Procedures:
- SP_BOOKINGSUPDATE_OPT_NEW
- SP_FTN_DUP
- SP_FTPSETORDERINFO
- SP_GETDELETEDINFORMATION
- SP_GETORDERINFO_SHIPINSTR
- SP_GETORDERINFORMATION
- SP_GETORDERINFORMATION_NEW
- SP_LOADPO
- SP_SHIPPINGSUPDATE
Table:
- Openpos
Please also take the backup of SSIS packages before replacing.
For Requestor
Interface Changes
- Confirm new column Master_grid is added to Openpos table
Test Notes
|
Test Scenario
|
Expected Results
|
1
|
Select a PO having size L and download the PO file using download Tab
|
it will download a file with respective PO details.
|
2
|
Check the PO file to confirm it has no duplicate L sizes
|
The data in the file should be unique.
|
Reference Document (Specifications or Production Support Break Fix)
Venkat - 2013-08-20 - 6411.300 - Spec - DSSCO Size L duplication